<%-- 
    Document   : DeleteData
    Created on : Dec 6, 2012, 2:19:07 AM
    Author     : FaveGanteng
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">


<%@ page import="java.sql.*" %>
<%
    /**
     * Mengambil parameter dari halaman FormMasukanData.html
     */
    String id = request.getParameter("id");
    Connection con = null;
    //String dbname = "jdbc:oracle:thin:@localhost:1521:XE";
     String dbname = "jdbc:oracle:thin:@172.23.9.185:1521:orcl";
    String status = "";
    ResultSet rs = null;
    try {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        //con = DriverManager.getConnection(dbname, "hr", "hr");
        con = DriverManager.getConnection(dbname, "MHS105314093", "MHS105314093");
        if (con == null) {
            status = "gagal";
        } else {
            status = "berhasil";
        }
    } catch (ClassNotFoundException ex) {
        status = "Driver Error";
    } catch (SQLException ex) {
        status = "gagal";
    }

    Statement st = con.createStatement();
    String kueri = "DELETE FROM rplopesanan WHERE idpesanan = '" + id + "'";

    int deleteData = st.executeUpdate(kueri);



%>


<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Delete Data</title>
    </head>
    <body>
    <style type="text/css">
        #main{
            border: solid;
            color: blue;
            background:white;
            font-weight: bold;
            margin-top: 100px;
            margin-left:120px;
            margin-right:127px;
            margin-bottom:135px;
            padding-right:60px; }

        #menuhor {
            list-style-type: none;
            margin: 0;
            padding: 0;
            float: center;
        }

        #menuhor li {
            margin: 0;
            padding: 0;
            float:left;
            text-align : center;
        }

        #menuhor a {
            display: block;
            width : 247px;
            color: #FFF;
            float : center;
            text-decoration: none;
            line-height:2.5;
            border-right: 3px solid white;
        }

        #menuhor a:hover {
            background: cyan;
        }
        #konten_utama{
            background-color:white;}

        #menuver{
            list-style-type: none;
            margin-left:-40px;
            margin-right:30px;
            padding:0;
            width : 170px;
            background-color:white;
            float:left;
        }
        #menuver li {
            margin:0;
            padding:0;
            float:center;
            text-align : center;
        }
        #menuver a {
            display:block;
            color:#FFF;
            text-decoration:none;
            padding:0.15px;
            line-height: 2.5;
            border-bottom: 3px solid white;
        }
        #menuver a:hover {
            background: cyan;
        }
        #footer{
            font-size: 14px;
            border: solid;
            color: blue;
            clear:both;
            text-align: center;
            background: white;
            margin-top: 350px;
            margin-bottom: 50px;
            height:70px;
            width :950px;
            float:center;

        }
        #konten{
            float:left;

            color: black;
            background: white;
            height:400px;
            width :730px
        }



    </style>
    <body background ="background1.jpg">
        <ul id="main">
            <center><img src="banner.jpg"width="1000" height="300">

                <br>
                <br>
                <ul id="menuhor" style="position:absolute;right:7px;left:173px;top:345px">
                    <font face="Comic sans MS">
                    <li><a href="HalamanUtama.jsp"><font color="Blue">Home</a> </li>
                    <li><a href="HalamanProfile.jsp"><font color="Blue">Profile</a></li>
                    <li><a href="HalamanWisata.jsp"><font color="Blue">Wisata</blink></a></li>
                    <li><a href="FormOrder.jsp"><font color="Blue">Order</a></li>
                </ul><br><br><hr>

                <ul id="konten_utama">

                    <ul id="menuver">
                        <center> Klik the link below to view packet travel</center>
                        <br>
                            <li><a href="HalamanWisata.jsp"><Marquee><font color="Blue">view packet travel </Marquee></a> </li>
                            <br>
                            
                    </ul>


                    <ul id="konten">
                        <form name="form1" method="post" action="HalamanPesanan.jsp">

                            <tr>
                                <td colspan="2"><strong></strong></td>
                            </tr>

                            <%
                                if (deleteData == 1) {
                                    out.println("Delete data berhasil");
                                } else {
                                    out.println("Delete data gagal");
                                }
                            %>
                            <INPUT TYPE="submit" VALUE="Lihat Pesanan">
                        </form>
                    </ul>



                    <br>
                    <br>
                    <br>
                    <ul id="footer">

                        Queries Executed: 0 queries | Page Generation Time: 0.00265 seconds <br>
                        Travel Agent 2.0.4 Beta 10 (Revision 363). Coded by Ardy. Skin coded by Amel and designed by Fave, Hohok
                        All registered trademarks belong to their respective owners. Travel Agent Online and all related content are trademark of Gravity CO. Ltd.
                    </ul></font>
                    </body>
                    </html>

                    